Personalization of MDX Queries

Answers of OLAP queries often cannot be visualized entirely and the user has to navigate through them to find relevant facts. One possible way to solve this problem is to personalize the queries. The basic idea behind the process of query personalization is that different users may find and see the facts they prefer without having to navigate. In this paper, we propose a framework for personalizing MDX queries. MDX allows the user to express complex queries on multidimensional data and to specify how the result will be presented on the screen. In this work, we present a preference model which allows the user to define his preferred dimensions and members. In addition, we provide an algorithm that, given an MDX query, a user profile and a visualization constraint, computes and displays the best answer to a user w.r.t. his (her) preferences and the constraints.